Summary functions

The Summary functions are all used to summarize field data in several different ways. Because of their unique summarization features, they have been grouped together as summary functions.The function name SummaryFunction takes the place of an actual function name.

Summary functions can be designed to perform operations on group data.

Sum (fld), Sum (fld, fld), Sum (fld, condFld), Sum (fld, condFld, cond), Sum (x)

SummaryFunction (fld)

SummaryFunction (fld, condFld)

SummaryFunction (fld, condFld, cond)

Average (fld), Average (fld, condFld), Average (fld, condFld, cond), Average (x)

StdDev (fld), StdDev (fld, condFld), StdDev (fld, condFld, cond), StdDev (x)

PopulationStdDev (fld), PopulationStdDev (fld, condFld), PopulationStdDev (fld, condFld, cond), PopulationStdDev (x)

Variance (fld), Variance (fld, condFld), Variance (fld, condFld, cond), Variance (x)

PopulationVariance (fld), PopulationVariance (fld, condFld), PopulationVariance (fld, condFld, cond), PopulationVariance (x)

Maximum (fld), Maximum (fld, condFld), Maximum (fld, condFld, cond), Maximum (x)

Minimum (fld), Minimum (fld, condFld), Minimum (fld, condFld, cond), Minimum (x)

Count (fld), Count (fld, condFld), Count (fld, condFld, cond), Count (x)

DistinctCount (fld), DistinctCount (fld, condFld), DistinctCount (fld, condFld, cond), DistinctCount (x)

Correlation (fld, fld), Correlation (fld, fld, condFld), Correlation (fld, fld, condFld, cond)

Covariance (fld, fld), Covariance (fld, fld, condFld), Covariance (fld, fld, condFld, cond)

WeightedAverage (fld, fld), WeightedAverage (fld, fld, condFld), WeightedAverage (fld, fld, condFld, cond)

Median (fld), Median (fld, condFld), Median (fld, condFld, cond)

PthPercentile (P, fld), PthPercentile (P, fld, condFld), PthPercentile (P, fld, condFld, cond)

NthSmallest (N, fld), NthSmallest (N, fld, condFld), NthSmallest (N, fld, condFld, cond)

Mode (fld), Mode (fld, condFld), Mode (fld, condFld, cond)

NthMostFrequent (N, fld), NthMostFrequent (N, fld, condFld), NthMostFrequent (N, fld, condFld, cond)

PercentOfSum

PercentOfAverage

PercentOfMaximum

PercentOfMinimum

PercentOfCount

PercentOfDistinctCount

Conditions for summary functions



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com